/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50729
 Source Host           : localhost:3306
 Source Schema         : tk

 Target Server Type    : MySQL
 Target Server Version : 50729
 File Encoding         : 65001

 Date: 07/01/2021 10:04:52
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tk_permission
-- ----------------------------
DROP TABLE IF EXISTS `tk_permission`;
CREATE TABLE `tk_permission` (
  `id` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `permission_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `permission_value` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `parent_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `create_time` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `update_time` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tk_permission
-- ----------------------------
BEGIN;
INSERT INTO `tk_permission` VALUES ('dsr21fef121feq', '角色管理', 'sys:menu:role', NULL, NULL, NULL, NULL, 'role');
INSERT INTO `tk_permission` VALUES ('dsr21fef121fer', '权限管理', 'sys:menu:permission', NULL, NULL, NULL, NULL, 'menu');
INSERT INTO `tk_permission` VALUES ('dsr21fef121fet', '文件管理', 'sys:menu:file', NULL, NULL, NULL, NULL, 'nfile');
INSERT INTO `tk_permission` VALUES ('dsr21fef121few', '用户管理', 'sys:menu:user', NULL, NULL, NULL, NULL, 'user');
INSERT INTO `tk_permission` VALUES ('dsr21fef121fey', '', 'sys:menu:base', NULL, NULL, NULL, NULL, '');
COMMIT;

-- ----------------------------
-- Table structure for tk_role
-- ----------------------------
DROP TABLE IF EXISTS `tk_role`;
CREATE TABLE `tk_role` (
  `id` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `role_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `role_desc` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `create_time` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `update_time` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tk_role
-- ----------------------------
BEGIN;
INSERT INTO `tk_role` VALUES ('ndeiownfi12', '超级管理员', '超级管理员', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for tk_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `tk_role_permission`;
CREATE TABLE `tk_role_permission` (
  `id` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `role_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `permission_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for tk_user
-- ----------------------------
DROP TABLE IF EXISTS `tk_user`;
CREATE TABLE `tk_user` (
  `id` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `org_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `org_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `user_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `user_password` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `create_time` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `sex` int(11) DEFAULT NULL,
  `update_time` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tk_user
-- ----------------------------
BEGIN;
INSERT INTO `tk_user` VALUES ('1284087603822866434', 'kk', NULL, NULL, 'kk', NULL, NULL, NULL, 0, NULL, 0, '1153658780@qq.com');
INSERT INTO `tk_user` VALUES ('rni2o1nro31', 'admin', '', '', 'admin', 'admin', '11111111111', '', NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for tk_user_role
-- ----------------------------
DROP TABLE IF EXISTS `tk_user_role`;
CREATE TABLE `tk_user_role` (
  `id` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `role_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;
